[dbo].[LicenseLegacyMap]

Property	Value
Created	10:31:26 AM Tuesday, March 02, 2010
Last Modified	11:40:03 AM Monday, February 20, 2012

Property

Value

Created

10:31:26 AM Tuesday, March 02, 2010

Last Modified

11:40:03 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Cluster Primary Key PK_LicenseLegacyMap: LicenseKey\LegacyLicenseCode$ $Indexes IX_LicenseLegacyMap_LegacyLicenseCode_LicenseKey: LegacyLicenseCode\LicenseKey$	LicenseKey	uniqueidentifier	16
$Cluster Primary Key PK_LicenseLegacyMap: LicenseKey\LegacyLicenseCode$ $Indexes IX_LicenseLegacyMap_LegacyLicenseCode_LicenseKey: LegacyLicenseCode\LicenseKey$	LegacyLicenseCode	nvarchar(50)	100

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_LicenseLegacyMap: LicenseKey\LegacyLicenseCode$

$Indexes IX_LicenseLegacyMap_LegacyLicenseCode_LicenseKey: LegacyLicenseCode\LicenseKey$

LicenseKey

uniqueidentifier

$Cluster Primary Key PK_LicenseLegacyMap: LicenseKey\LegacyLicenseCode$ $Indexes IX_LicenseLegacyMap_LegacyLicenseCode_LicenseKey: LegacyLicenseCode\LicenseKey$

LegacyLicenseCode

nvarchar(50)

100

	Name	Columns	Unique
$Cluster Primary Key PK_LicenseLegacyMap: LicenseKey\LegacyLicenseCode$	PK_LicenseLegacyMap	LicenseKey, LegacyLicenseCode
	IX_LicenseLegacyMap_LegacyLicenseCode_LicenseKey	LegacyLicenseCode, LicenseKey

Name

Columns

Unique

$Cluster Primary Key PK_LicenseLegacyMap: LicenseKey\LegacyLicenseCode$

PK_LicenseLegacyMap

LicenseKey, LegacyLicenseCode

IX_LicenseLegacyMap_LegacyLicenseCode_LicenseKey

LegacyLicenseCode, LicenseKey

Name	Columns
FK_LicenseLegacyMap_License	LicenseKey->[dbo].[License].[LicenseKey]

Name

Columns

FK_LicenseLegacyMap_License

LicenseKey->[dbo].[License].[LicenseKey]

SQL Script

CREATE TABLE [dbo].[LicenseLegacyMap]
(
[LicenseKey] [uniqueidentifier] NOT NULL,
[LegacyLicenseCode] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[LicenseLegacyMap] ADD CONSTRAINT [PK_LicenseLegacyMap] PRIMARY KEY CLUSTERED ([LicenseKey], [LegacyLicenseCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_LicenseLegacyMap_LegacyLicenseCode_LicenseKey] ON [dbo].[LicenseLegacyMap] ([LegacyLicenseCode], [LicenseKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[LicenseLegacyMap] ADD CONSTRAINT [FK_LicenseLegacyMap_License] FOREIGN KEY ([LicenseKey]) REFERENCES [dbo].[License] ([LicenseKey])
GO